{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"JOBNUMBER","type":"number","width":6,"decimals":0},{"name":"CUSTOMER","type":"character","width":30},{"name":"CONTACT","type":"character","width":20},{"name":"ADDRESS","type":"character","width":40},{"name":"PHONEWORK","type":"number","width":12,"decimals":0},{"name":"PHONEHOME","type":"number","width":12,"decimals":0},{"name":"DATEIN","type":"date","width":8},{"name":"COSTCTR","type":"character","width":10},{"name":"REPAIRTYPE","type":"character","width":1},{"name":"UNITTYPE","type":"character","width":6},{"name":"SERIALNO","type":"character","width":20},{"name":"ASSETNO","type":"character","width":10},{"name":"EXTRA1","type":"character","width":6},{"name":"SERIALNO1","type":"character","width":20},{"name":"EXTRA2","type":"character","width":6},{"name":"SERIALNO2","type":"character","width":20},{"name":"EXTRA3","type":"character","width":6},{"name":"SERIALNO3","type":"character","width":20},{"name":"EXTRA4","type":"character","width":6},{"name":"SERIALNO4","type":"character","width":10},{"name":"FAULT","type":"memo","width":10,"read":false},{"name":"WARRANTY","type":"logical","width":1},{"name":"DATESTART","type":"date","width":8},{"name":"TECHID","type":"character","width":4},{"name":"TECHREPORT","type":"memo","width":10,"read":false},{"name":"DATEOUT","type":"date","width":8},{"name":"QTY1","type":"number","width":4,"decimals":0},{"name":"PARTDESC1","type":"character","width":60},{"name":"PARTCOST1","type":"number","width":7,"decimals":2},{"name":"SRO1","type":"number","width":8,"decimals":0},{"name":"QTY2","type":"number","width":4,"decimals":0},{"name":"PARTDESC2","type":"character","width":60},{"name":"PARTCOST2","type":"number","width":7,"decimals":2},{"name":"SRO2","type":"number","width":8,"decimals":0},{"name":"QTY3","type":"number","width":4,"decimals":0},{"name":"PARTDESC3","type":"character","width":60},{"name":"PARTCOST3","type":"number","width":7,"decimals":2},{"name":"SRO3","type":"number","width":8,"decimals":0},{"name":"QTY4","type":"number","width":4,"decimals":0},{"name":"PARTDESC4","type":"character","width":60},{"name":"PARTCOST4","type":"number","width":5,"decimals":2},{"name":"SRO4","type":"number","width":8,"decimals":0},{"name":"QTY5","type":"number","width":4,"decimals":0},{"name":"PARTDESC5","type":"character","width":60},{"name":"PARTCOST5","type":"number","width":7,"decimals":2},{"name":"SRO5","type":"number","width":8,"decimals":0},{"name":"QTY6","type":"number","width":4,"decimals":0},{"name":"PARTDESC6","type":"character","width":60},{"name":"PARTCOST6","type":"number","width":7,"decimals":2},{"name":"SRO6","type":"number","width":8,"decimals":0},{"name":"PARTCOST","type":"number","width":7,"decimals":2},{"name":"TAXCOST","type":"number","width":7,"decimals":2},{"name":"LABOURHOUR","type":"number","width":7,"decimals":2},{"name":"LABOURRATE","type":"number","width":7,"decimals":2},{"name":"LABOURCOST","type":"number","width":7,"decimals":2},{"name":"TOTAL","type":"number","width":7,"decimals":2},{"name":"COMPLETE","type":"logical","width":1},{"name":"INVOICED","type":"logical","width":1},{"name":"DELETED","type":"logical","width":1}],"n_rows":12,"rows_kept":12,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three_memo","encoding_class":"enc_absent","reader":"statdb_count/9"}
[1,null,null,null,null,null,"1993-05-10",null,"D",null,"243",null,null,null,null,null,null,null,null,null,null,null,null,"XX",null,"1993-05-10",null,null,0.00,null,null,null,0.00,null,null,null,0.00,null,null,null,null,null,null,null,0.00,null,null,null,0.00,null,0.00,0.00,0.00,0.00,0.00,0.00,true,null,false]
[2,null,null,null,null,null,"1993-05-10",null,"D",null,"312",null,null,null,null,null,null,null,null,null,null,null,null,"XX",null,"1993-05-10",null,null,0.00,null,null,null,0.00,null,null,null,0.00,null,null,null,null,null,null,null,0.00,null,null,null,0.00,null,0.00,0.00,0.00,0.00,0.00,0.00,true,null,false]
[3,"Fred","Fred","309:120",8762,2349640,"1993-05-26","4937 -4123","D","AM2CI","3476234987","4398723987",null,null,null,null,null,null,null,null,null,null,null,"CH",null,"1993-09-24",2,"Big Hammer",34.00,null,1,"Large Widget",45.00,null,3,"Fred",45.00,null,3,"Small Pickets",32.00,null,14,"Green Stckers",12.00,null,0,null,0.00,null,512.00,0.00,1.00,50.00,50.00,562.00,true,null,false]
[4,"Fred","Fred","309:402",2387,3272383,"1993-05-26","2987 -2342","D","AM2CI","234","35906",null,null,null,null,null,null,null,null,null,false,"1993-07-08","NR",null,"1993-07-08",1,"Samll Sprocket",20.00,342762,0,null,0.00,null,null,null,0.00,null,null,null,null,null,null,null,0.00,null,null,null,0.00,null,20.00,10.00,2.00,50.00,100.00,130.00,true,null,false]
[6,"Fred","Fred","34 Eric St",34427,34262378,"1993-07-08","46637-3827","D","AM2FX","wq86q","3246",null,null,null,null,null,null,null,null,null,true,"1993-07-08","NR",null,"1993-07-09",2,"Sprocket",20.45,null,0,null,0.00,null,null,null,0.00,null,null,null,null,null,null,null,0.00,null,null,null,0.00,null,40.90,1.09,1.00,50.00,50.00,91.99,true,null,false]
[7,"Eric Jones","Eric","40 The Avenue",4327,3428798,"1993-07-09","9844 -2343","D","AMLC2","13498734290","329823876",null,null,null,null,null,null,null,null,null,true,null,"CH",null,"1993-09-24",2,"Small Widget",22.45,349763,null,null,0.00,null,null,null,0.00,null,null,null,null,null,null,null,0.00,null,null,null,0.00,null,44.90,1.00,1.00,50.00,50.00,95.90,true,null,false]
[8,"Fred Jones","32876","309:120",2387,2987,"1993-12-10","34876-2384","D","AM2VI","sdfhlkj","sdff",null,null,null,null,null,null,null,null,null,false,null,"XX",null,"1993-12-10",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,null,0.00,0.00,true,null,false]
[9,"Andrew Hutchison","Andrew","2B Ornottobe St",3816331,null,"1994-01-06",null,"D","AMC660","346743987","45738fkjls","APIW2","345432434",null,null,null,null,null,null,null,true,"1995-11-08","BM",null,"1994-01-06",1,"Video Board",40.00,1235678,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40.00,0.00,1.00,50.00,50.00,90.00,true,null,false]
[10,"David Jones","David","c/o AMTC, Royal St, East Perth",2356466,0,"1994-02-08","4748 -5445","D","AMSE","4374538","338949",null,null,null,null,null,null,null,null,null,null,"1994-02-08","EH",null,"1994-02-08",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.00,0.00,2.00,50.00,100.00,100.00,true,null,false]
[11,"Ken Taylor","Ken","57 St Leonards Ave, West Leederville",3445,34423,"1994-06-25","43789-8348","D","AMQ700","9809845",null,null,null,null,null,null,null,null,null,null,null,null,"XX",null,"1994-06-25",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.00,0.00,null,null,null,0.00,true,null,false]
[12,"Fred Jones","97342","43983",433007,45389,"1995-11-08","34342-98","D","F386","12345","1343",null,null,null,null,null,null,null,null,null,false,"1996-05-23","AW",null,"1996-05-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.50,100.00,50.00,50.00,true,null,false]
[13,"Tarin  Haig","Tarin","Blah",3704584,0,"1996-05-23",null,"P","AML475","987","2309",null,null,null,null,null,null,null,null,null,null,"1996-05-23","NR",null,"1996-05-23",1,"8Mb SIMM",290.00,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,290.00,0.00,1.00,85.00,85.00,375.00,true,null,false]